tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 18820070-9df9-4d53-992b-2d59a55c8245
Sheet: Sheet1

Supplementary table 6: Unique repeats found in IIV-3 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | IIV-6
Sequence | Indices | Period size | Copy number | Match identity
UNIQUE REPEATS
caacaa aataatcaac taact | 16835--16901 | 21 | 3.2 | 95
t tctattttta attc | 22260--22298 | 15 | 2.6 | 100
gtgttaa aattg | 27184--27209 | 12 | 2.2 | 100
aacat taaaataat | 30366--30393 | 14 | 2 | 100
a gagtatagta t | 32550--32591 | 12 | 3.5 | 100
at aaaaaaataa tg | 33599--33639 | 14 | 2.9 | 100
[NAME] t | 34377--34416 | 15 | 2.7 | 96
ggtcttg gatta | 34634--34664 | 12 | 2.6 | 100
gaacgacg acgaggg | 42863--42903 | 15 | 2.7 | 100
ggagaac gacgacgg | 42944--42972 | 15 | 1.9 | 100
ttaat gtttaaaaa | 52346--52372 | 14 | 1.9 | 100
ttaattaat t | 52412--52436 | 10 | 2.5 | 100
taatttt aaatatata | 58434--58475 | 16 | 2.6 | 100
[NAME] | 62954--62981 | 14 | 2 | 100
acccccagtt acaaa | 67651--67698 | 15 | 3.2 | 100
aatccac caattcgtta t | 67844--67884 | 18 | 2.3 | 100
[NAME] | 69202--69241 | 15 | 2.7 | 100
[NAME] | 69256--69285 | 14 | 2.1 | 100
[NAME] | 71262--71340 | 12 | 6.6 | 100
at aaccatgaag aaaaac | 73729--73768 | 18 | 2.2 | 95
[NAME] | 77426--77450 | 12 | 2.1 | 100
[NAME] | 82568--82593 | 12 | 2.2 | 100
ca accaagattt ggatca | 82919--82972 | 18 | 3 | 100
tacaa acaatctc | 83196--83225 | 13 | 2.3 | 100
tttctatat tttcat | 83302--83347 | 15 | 3 | 96
a taatttagaa gtttaag | 85370--85412 | 18 | 2.4 | 100
[NAME] | 91324--91387 | 17 | 3.8 | 97
[NAME] t | 91984--92011 | 8 | 3.5 | 100
[NAME] | 92168--92201 | 15 | 2.3 | 100
ctcctag aagaagccca t | 108154--108201 | 18 | 2.7 | 96
c agtcctgtac a | 108350--108385 | 12 | 3 | 95
caccgagaag aagtccat | 108541--108620 | 18 | 4.4 | 100
a gacgttcatc gagtcgttct | 108840--108943 | 21 | 5 | 98
taa ttttgtaatt | 110038--110064 | 13 | 2.1 | 100
g gaaac | 110520--110546 | 6 | 4.5 | 100
[NAME] | 117875--117918 | 12 | 3.7 | 100
at tatattatac ca | 119139--119166 | 14 | 2 | 100
[NAME] gaaaaatatg gaagtgaata ctatattaac tcagatgcat ca | 128006--128259 | 57 | 4.5 | 96
[NAME] | 132031--132064 | 13 | 2.6 | 100
cgcctaa atttt | 138354--138399 | 12 | 3.8 | 100
[NAME] | 139983--140012 | 15 | 2 | 100
[NAME] | 147812--147839 | 13 | 2.2 | 100
g accaggatta ggacctggag ttg | 151659--151709 | 24 | 2.1 | 100
gaagatgt tatattaaag | 159873--159911 | 18 | 2.2 | 100
[NAME] | 162692--162727 | 16 | 2.3 | 100
[NAME] gaagcccaac aagaagc | 162814--162901 | 24 | 3.7 | 96
gat gaagaatatg ga | 166018--166060 | 15 | 2.9 | 100
[NAME] | 181716--181748 | 15 | 2.2 | 100
a gaagattttc aaga | 182870--182951 | 15 | 5.5 | 100
[NAME] | 182943--182971 | 15 | 1.9 | 100
t tttgtttg | 191030--191059 | 9 | 3.3 | 100
[NAME] | 192208--192253 | 15 | 3.1 | 100
t tggcaaatta ctattat | 194090--194127 | 18 | 2.1 | 100
ttt attcattttt taa | 204578--204615 | 16 | 2.4 | 100
Spreadsheet: 120327d1315215061-excel-2007-how-to-autopopulate-cells-with-the-used-of-h-and-vlookup-quotation
Sheet: OutputSheet

ITEM  NO |  | 20110905-2
[NAME]
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | TEST 2
[NAME] |  |  |  |  |  |  |  |  |  | SUBJECT :
 |  | ABCDEFG ENGINEERING CO., LTD |  |  |  |  |  |  |  |  |  |  | JS / 110905-2
QUOTED TO |  |  |  |  |  |  |  |  |  | QUOTATION NO.
 |  | 1010 MAIN STREET, ETC, ETC |  |  |  |  |  |  |  |  |  |  | 50% IN ADVANCE
ADDRESS |  |  |  |  |  |  |  |  |  | TERM OF PAYMENT |  |  | 50% - 30 DAYS
 |  | [PHONE] |  |  |  | FAX: | [PHONE] |  |  |  |  |  | 2011-09-05 00:00:00
TEL |  |  |  |  |  | EMAIL: | [NAME] |  |  | DATE :
ITEM | CODE |  |  |  |  | [NAME] |  |  |  | QUANTITY |  | UNIT PRICE |  |  | AMOUNT
1 | DB 001 |  | DB 001 LINE 1 |  |  |  |  |  |  | 20 |  | 25 |  |  | 500
 |  |  | DB 001 LINE 2 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 | AV 001 |  | AV 001 LINE 1 |  |  |  |  |  |  | 30 |  | 100 |  |  | 3000
 |  |  | AV 001 LINE 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3500
 |  |  |  |  |  |  |  |  |  | SUB TOTAL
 |  | 30 DAYS |  |  |  |  | 12 |  | Months |  |  |  |  |  | 245
DELIVERY TIME |  |  |  |  | WARANTY |  |  |  |  | V.A.T.
 |  | - |  |  |  |  |  | 30 | Days |  |  |  |  |  | 3745
INSTALLATION |  |  |  |  | VALIDITY FIRM |  |  |  |  | NET TOTAL
NOTE:
Spreadsheet: 381428d1425660814-border-lines-are-not-showing-for-some-cells-todofix
Sheet: -- To Do --

681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
x | x | x | x | x | x | x | x | x
Spreadsheet: 46515d1245346959-compare-two-columns-text-to-date-rental_quotes_withsummery_dummy
Sheet: Summary

 |  | Percentages
# [NAME] | 25 |  | Total number of quotes to date
# of Active | 1 | 0.04 | Total number of Quotes still active
# of Wins | 1 | 0.04 | Total number of Quotes converted to a rental
# of Cold | 1 | 0.04 | Total number of Quotes that have not be converted in any way.
# of Sold | 0 | 0 | Total number of Quotes converted to a sold truck
# of Dead | 21 | 0.84 | Total number of Quotes that will not be converted.
# of Lost | 1 | 0.04 | Total number of Quotes lost to competition or a reallocation of resources by the customer.
# of Items Quoted | 215 |  | Total number of Trucks quoted
 |  | 1
 | Salesman | Active | Wins | Cold | Sold | Lost | Dead | Totals
 | Perlowin | 0 | 0 | 0 | 0 | 0 | 7 | 7
 | [NAME] | 2 | 1 | 0 | 0 | 0 | 3 | 6
 | Young | 2 | 6 | 0 | 0 | 0 | 9 | 17
 | Shively | 2 | 1 | 0 | 1 | 0 | 7 | 11
 | Roper | 3 | 2 | 1 | 0 | 0 | 5 | 11
 | [NAME] | 2 | 1 | 0 | 0 | 0 | 2 | 5
 | Aurand | 2 | 2 | 0 | 0 | 0 | 1 | 5
 | Cummings | 3 | 2 | 0 | 0 | 0 | 2 | 7
 | [NAME] | 1 | 0 | 0 | 0 | 1 | 4 | 6
 | Heichemer | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | Yerdon | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Coordinator | 2 | 1 | 0 | 0 | 0 | 0 | 3
 |  |  |  |  |  | Grand Total |  | 79
 | Salesmen | Jan. | Feb. | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | [NAME] | 0
 | Young | 0
 | Shively | 0
 | Roper | 0
 | [NAME] | 0
 | Aurand | 0
 | Cummings | 0
 | [NAME] | 0
 | Heichemer | 0
 | Yerdon | 0
 | Coordinator | 0
Spreadsheet: 3a19b501-1f2a-4334-807b-10773a18fdce
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Metro One | 74948819222 | Crystal Lewis | Holiday | 2000-09-19 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 74948818126 | [NAME] | Give Me [NAME] | 2001-12-18 | Compact Disc | P & W | 8.99 | Y | Available
Metro One | 74948820198 | Crystal Lewis | More Live | 2002-05-22 | Music DVD | Pop | 19.98 | Y | Available
Metro One | 80688448325 | Crystal Lewis | Beauty For Ashes | 1996-09-23 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 80688496821 | Crystal Lewis | [NAME] | 1996-11-05 | Compact Disc | Spanish | 13.99 | Y | Available
Metro One | 74948818720 | Crystal Lewis | Fearless | 2000-04-24 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 74948818829 | Crystal Lewis | La Colecion | 2000-09-19 | Compact Disc | Spanish | 13.99 | Y | Available
Metro One | 74948819925 | Crystal Lewis | More | 2001-09-18 | Compact Disc | Ac Pop | 9.99 | Y | Available
Metro One | 80688442620 | Crystal Lewis | Bride, The | 1996-02-23 | Compact Disc | Ac | 16.99 | Y | Available
Metro One | 80688442729 | Crystal Lewis | Crystal Lewis: Greatest Hits | 1996-02-23 | Compact Disc | Ac | 9.99 | Y | Available
Metro One | 80688551827 | Crystal Lewis | Gold | 1998-02-17 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 80688443122 | Crystal Lewis | Himnos | 1996-03-08 | Compact Disc | Spanish | 13.99 | Y | Available
Metro One | 80688442828 | Crystal Lewis | Hymns My Life | 1996-03-01 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 80688579920 | Crystal Lewis | Oro | 1998-04-14 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 74948830524 | [NAME] | [NAME] | 2012-02-28 | Compact Disc | Praise | 13.99 | Y | Available
Metro One | 74948830302 | Crystal Lewis | Home For The Holidays | 2010-10-26 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 74948830401 | Crystal Lewis | Plain And Simple | 2011-06-07 | Compact Disc | Pop | 13.98 | Y | Available
Metro One | 74948821027 | Crystal Lewis | [NAME] | 2006-03-14 | Compact Disc | Children | 13.99 | Y | Available
Metro One | 74948820723 | Crystal Lewis | Holy, Holy, Holy | 2002-09-17 | Compact Disc | Ac | 13.99 | Y | Available
Metro One | 74948820525 | Crystal Lewis | Santo, Santo, Santo | 2003-02-08 | Compact Disc | Spanish | 13.99 | Y | Available
Metro One | 74948820921 | Crystal Lewis | See | 2005-05-03 | Compact Disc | Ac Pop | 13.99 | Y | Available
Metro One | 74948830623 | [NAME] | Power In Weakness | 2012-08-14 | Compact Disc | Rock | 13.99 | Y | Available
Spreadsheet: 137420d1327094957-calculating-rent-due-with-conditional-formulas-rent-chart-1
Sheet: Sheet1

ROOM # | FIRST NAME | LAST NAME | MOVE-IN DATE OF NEW GUEST | WEEKLYROOM RATE W/TAX FOR NEW GUEST | WEEKLYROOM RATE (NO TAX) OF LONG TERM GUEST | MONTHLY ROOM RATE OF LONG TERM GUEST | PAID THRU | TODAY'S DATE | # OF DAYS OVERDUE | # OF (EXACT) WEEKS OVERDUE | # OF WEEKS OVERDUE | # OF MONTHS OVERDUE | AMOUNT OWED
1 | [NAME] | Smith |  |  | 145 |  | 2012-01-04 00:00:00 | 2012-01-20 00:00:00 | 16 | 2.285714285714286 | 3 |  | 435
2 | [NAME] | [NAME] |  |  | 145 |  | 2012-01-10 00:00:00 | 2012-01-20 00:00:00 | 10 | 1.428571428571429 | 2 |  | 290
3 | [NAME] | [NAME] |  |  | 150 |  | 2012-02-15 00:00:00 | 2012-01-20 00:00:00 | 0 | 0 | 0 |  | 0
4 | [NAME] | Henderson * | 12/15/11 | 159.5 | 145 |  | 2012-01-05 00:00:00 | 2012-01-20 00:00:00 | 15 | 2.142857142857143 | 3
5 | [NAME] | Dressler |  |  |  | 628 | 2012-01-31 00:00:00 | 2012-01-20 00:00:00
6 | [NAME] | Morris |  |  |  | 628 | 2011-08-30 00:00:00 | 2012-01-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 725
 |  | *  [NAME] moved in on 12/15/11 and paid $159.50 per week his first 3 weeks. As of 1/20/12 he owes $159.50 for his 4th week of rent (1/5/12 to 1/12/12) and he owes $145 for the 5th week of rent (1/12/12 thru 1/19/12) and $145 for the 6 week of rent 1/20/12 thru 1/27/12).  So total he owes now is $449.50 which is: $159.50 + $145 + $145.
Spreadsheet: 840632d1692877551-use-lookup-function-to-total-all-cells-that-contain-text-mockexample
Sheet: Sheet1

animal | cost
[NAME] | 7
[NAME] | 10
choclate spaniel | 15
shorthair | 6
spynx | 12
burmese | 18
dog | 32
cat | 36
Spreadsheet: 011c84f8-b631-45fe-93a4-5346bb23b489
Sheet: Sheet1

HELIN Spreadsheet 2003-2004 (URI only) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Last updated: 11/21/2008 ajr
Title | Price | Type | Subscription Year | Notes
ABC-CLIO America History and Life & Historical Abstracts | 10650 | [NAME] | Fiscal | 2-6 simultaneous users
CSA ASFA | 6322 | [NAME] | Fiscal
CSA EconLit | 3728 | [NAME] | Fiscal
CSA International Pharmaceutical Abstracts | 3124 | [NAME] | Fiscal
CSA PAIS | 4536 | [NAME] | Fiscal
CSA Physical Education Index | 923 | [NAME] | Fiscal
CSA PsycINFO | 13584 | [NAME] | Fiscal
Cambridge RefWorks | 7675 | [NAME] | Fiscal
CSA Sociological Abstracts | 3513 | [NAME] | Fiscal
CQ Researcher | 1200 | [NAME] | Fiscal | 10 simul. users per site
EBSCO Academic Search Premier | 17550 | [NAME] | Fiscal
FirstSearch Base Package | 9291 | [NAME] | Fiscal | Base Package with 9 sim. users
First Search MLA International Bibliography | 5578 | [NAME] | Fiscal
[NAME] | 3414 | [NAME] | Fiscal
Mergent FIS online | 8300 | [NAME] | Fiscal
Music Index | 2195 | [NAME] | Fiscal
ProQuest ABI Inform | 17500 | [NAME] | Fiscal
Wilson Readers Guide Retro 1890-1982 | 7669 | [NAME] | Fiscal | 4 simultaneous users. The one-time charge for Retro is slightly larger for those libraries that did not subscribe to the RG Abstracts.
Spreadsheet: 78e860fe-a9a6-4af5-a013-6333059056c6
Sheet: Human Associated

Analytical Key | [NAME] (ABMI) | Species (Scientific Name) | Intactness (%) | Occurrence in the Boreal Plains Ecozone (%) | Relative to Reference | Threat
AmericanCrow | American Crow | Corvus brachyrhynchos | 26.395991650285 | 22.83 | Above | ESRD - Secure
AmericanRobin | American [NAME] | Turdus migratorius | 70.59811575108901 | 50.22 | Above | ESRD - Secure
BankSwallow | Bank Swallow | Riparia riparia | 54.30219308131001 | 7.37 | Above | ESRD - Secure
BarnSwallow | [NAME] | Hirundo rustica | 21.469008848816 | 5.63 | Above | ESRD - Sensitive | COSEWIC - Threatened
BlackbilledMagpie | Black-billed Magpie | Pica hudsonia | 18.41821995123101 | 7.59 | Above | ESRD - Secure
BlackcappedChickadee | Black-capped Chickadee | Poecile atricapillus | 98.863980453962 | 30.37 | Above | ESRD - Secure
BlueJay | [NAME] | Cyanocitta cristata | 99.834311144337 | 14.3 | Below | ESRD - Secure
BrewersBlackbird | Brewer's Blackbird | Euphagus cyanocephalus | 98.908150967947 | 5.56 | Above | ESRD - Secure
BrownheadedCowbird | Brown-headed [NAME] | Molothrus ater | 91.452275729728 | 27.43 | Above | ESRD - Secure
CedarWaxwing | Cedar Waxwing | Bombycilla cedrorum | 99.7232647853876 | 27.41 | Below | ESRD - Secure
EuropeanStarling | European Starling | Sturnus vulgaris | 65.49512792236601 |  | Above | ESRD - Secure
HouseWren | House Wren | Troglodytes aedon | 50.70518621418799 | 10.07 | Above | ESRD - Secure
RedwingedBlackbird | Red-winged [NAME] | Agelaius phoeniceus | 53.17227584731 | 29.48 | Above | ESRD - Secure
SavannahSparrow | [NAME] | Passerculus sandwichensis | 14.311337366271 | 14.72 | Above | ESRD - Secure
SongSparrow | [NAME] | [NAME] | 13.59666311092599 | 15.17 | Above | ESRD - Secure
TreeSwallow | [NAME] | Tachycineta bicolor | 96.052848876931 | 24.78 | Above | ESRD - Secure
WarblingVireo | Warbling Vireo | Vireo gilvus | 84.393742100205 | 27.2 | Above | ESRD - Secure
YellowWarbler | [NAME] | Dendroica petechia | 66.18299938196401 | 21.76 | Above | ESRD - Secure
 |  | Average Intactness
Spreadsheet: 26321c5b-9e13-491c-84e8-096f71443226
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43601978 | 2014-10-16 06:42:22 | AXIS | 1 | 7 | 4 | 1007284 | Temple58 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43602117 | 2014-10-16 07:00:43 | ALLIES | 0 | 1 | 7 | 1007284 | Temple58 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43629032 | 2014-10-18 07:46:32 | AXIS | 0 | 4 | 6 | 1594070 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43700628 | 2014-10-23 06:51:48 | AXIS | 1 | 6 | 2 | 1059626 | TRC777 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43700920 | 2014-10-23 07:34:35 | ALLIES | 0 | 5 | 6 | 1059626 | TRC777 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 776617d1649830263-sumifs-with-four-contions-criteria-and-help-with-dropdown-list-180
Sheet: Sheet1

 |  |  | Projects | Items | [NAME] | Amount
 |  |  | Green_Street | first_floor | PYRAMID PLUS SOUTH LLP | 70
 |  |  | Green_Street | Basement | PYRAMID PLUS SOUTH LLP | 50
 |  |  | Katherine_Road | Disable_Toilet | PYRAMID PLUS SOUTH LLP | 40
 |  |  | Upton_Lane | Basement | PYRAMID PLUS SOUTH LLP | 60
Spreadsheet: mary_fischer__25619__77L
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L
COMPANY NAME   PBM Mechanical Inc.
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Misc A/R - 3rd party |  | 61615 |  | -61615 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Dec

December Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am |  |  | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 0 | 0 | 1
6:00am-6:59am |  |  | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 0 | 0 | 2
7:00am-7:59am |  |  | 3.5 |  | 7:00am-7:59am |  |  | 2 |  | 7:00am-7:59am | 0 | 0 | 5.5
8:00am-8:59am |  |  | 5 |  | 8:00am-8:59am |  |  | 2 |  | 8:00am-8:59am | 0 | 0 | 7
9:00am-9:59am |  |  | 5.5 |  | 9:00am-9:59am |  |  | 2 |  | 9:00am-9:59am | 0 | 0 | 7.5
10:00am-10:59am |  |  | 5 |  | 10:00am-10:59am |  |  | 3 |  | 10:00am-10:59am | 0 | 0 | 8
11:00am-11:59am |  |  | 5 |  | 11:00am-11:59am |  |  | 3 |  | 11:00am-11:59am | 0 | 0 | 8
12:00pm-12:59pm |  |  | 5 |  | 12:00pm-12:59pm |  |  | 2 |  | 12:00pm-12:59pm | 0 | 0 | 7
1:00pm-1:59pm |  |  | 5 |  | 1:00pm-1:59pm |  |  | 2 |  | 1:00pm-1:59pm | 0 | 0 | 7
2:00pm-2:59pm |  |  | 4.5 |  | 2:00pm-2:59pm |  |  | 3 |  | 2:00pm-2:59pm | 0 | 0 | 7.5
3:00pm-3:59pm |  |  | 3.5 |  | 3:00pm-3:59pm |  |  | 3 |  | 3:00pm-3:59pm | 0 | 0 | 6.5
4:00pm-4:49pm |  |  | 1.5 |  | 4:00pm-4:49pm |  |  | 2 |  | 4:00pm-4:49pm | 0 | 0 | 3.5
5:00pm-5:59pm |  |  | 1 |  | 5:00pm-5:59pm |  |  | 2 |  | 5:00pm-5:59pm | 0 | 0 | 3
6:00pm-6:59pm |  |  | 1 |  | 6:00pm-6:59pm |  |  | 2 |  | 6:00pm-6:59pm | 0 |  | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm |  |  | 2 |  | 7:00pm-8:00pm | 0 | 0 | 2
 | 0 | 0 | 48.5 |  |  | 0 | 0 | 30 |  |  | 0 | 0 | 78.5
Spreadsheet: 696489d1600853321-cashflow-formula-needed-for-partial-paymen-base-on-date-book2-4-
Sheet: Payment Term

Type | Payment | Term
A Sponser | 0.4 | 0 |  | 0= Day when sign contract
A Sponser | 0.4 | 30
A Sponser | 0.2 | 90
B Sponser | 0.5 | 0
B Sponser | 0.5 | 90
C Sponser | 0.4 | 0
C Sponser | 0.3 | 30
C Sponser | 0.3 | 60
D Sponser | 1 | 0
Spreadsheet: 233139d1367625542-employee-ranking-spreadsheet-based-on-key-areas-employee-productivity-1-
Sheet: Top Sales Ranking

Top Sales Associate |  |  | Multiple %
 | Name | Rank
 | Employee #1 | 4
 | Employee #2 | 5
 | Employee #3 | 7
 | Employee #4 | 1
 | Employee #5 | 6
 | Employee #6 | 2
 | Employee #7 | 3
Top Sales Associate |  | Rank | Average $ Transaction
 | Name | Sales Per Hour | Average $ Transaction | Multiple % | Accessory % | Handheld % | Sports Illustrated
 | Employee #1 | 1 | 4 | 4 | 4 | 1 | 3
 | Employee #2 | 7 | 5 | 5 | 6 | 7 | 4
 | Employee #3 | 4 | 7 | 7 | 1 | 2 | 7
 | Employee #4 | 3 | 1 | 1 | 2 | 5 | 5
 | Employee #5 | 5 | 6 | 6 | 5 | 6 | 6
 | Employee #6 | 2 | 2 | 2 | 3 | 4 | 1
 | Employee #7 | 6 | 3 | 3 | 6 | 3 | 2
Spreadsheet: 687932d1595497124-if-vlookup-combination-dates-sample-aligw
Sheet: Sheet2

user name | Pending Acceptance of Invitation (Date)
Rajveer Dillon
Dillon Mohamed
[NAME]
Raife Galindo
[NAME]
Joann Preston
[NAME]
[NAME]
[NAME]
Poppy-Mae Hamer
Paris Rosa
[NAME]
[NAME]
Ksawery Villarreal
Anabella Nolan
[NAME]
[NAME]
 | List dates only if invitation is not yet accepted accepted
Spreadsheet: 479846d1473619787-find-name-that-carries-the-shift-on-that-day-modulo-prova-1-
Sheet: Ottobre (1)

 |  | [NAME]
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 | [NAME] dovrebbe contenere il resoconto giornaliero
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 | Francesco B
 | Virginia | Virginia | Virginia
 | Stefania | Stefania | Stefania
 | Giovanni
 | Simone | Simone | Simone
 | Valentina | Valentina | Valentina
Spreadsheet: 172688d1344294189-how-to-reference-to-the-cell-adjacent-to-the-cell-of-selection-excel-forum-question-day92
Sheet: Sheet1

2012-08-01 00:00:00 |  | 2012-08-02 00:00:00 |  | 2012-08-03 00:00:00
A | B | A | B | A | B
22 | 33 | 21 | 35 | 25 | 11
A |  | [NAME] value |  | B value correspond to max A day
Spreadsheet: richard_ring__31525__PECO_Accts_12102001
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-12-10 00:00:00
 |  |  | Rate | Rate |  |  | [NAME] | [NAME] | Start | Contract | Peak
 | Customer Name | Account No. | Class | Code | Strata | Rate Code Description | Type | Cycle | Date | Status | Dmd | [NAME] Obl. | Trx Obl. | Price | [NAME]
 | [NAME] | 231172239726 | GS | CM | 6 |  | Mo | 11 | 1999-04-16 00:00:00 | Unknown | 48 | 48 | 27.3 | 61.9 | RICH PE
 | HOLLYWOOD OIL CO | 400708742517 | GS | CM | 4 | Commercial measured | Mo |  | 1999-01-12 00:00:00 | Expired | 18.5 | 13 | 13 |  | BYBERRY
 | CHELTENHAM SHOPPING | 401807426010 | PD | PD | 57 | Primary Distribution Power | Mo |  | 1999-02-26 00:00:00 | Bundled | 525.8 | 415.4 | 415.4 |  | CEDARBRO
 | CHELTENHAM SHOPPING | 401807426416 | GS | C | 9 | Commercial - no demand | Mo |  | 1999-01-28 00:00:00 | Bundled | 6.1 | 2 | 2 |  | CEDARBRO
 | CHELTENHAM SHOPPING | 401807861018 | GS | C | 9 | Commercial - no demand | Mo |  | 1999-01-28 00:00:00 | Bundled | 8.2 | 2 | 2 |  | MIDD PE
 | TETRATEC CORP | 451038591512 | GS | GS | 6 | General Service | Mo |  | 1999-01-15 00:00:00 | Expired | 390.5 | 356 | 356 | 49.7 | BYBERRY
 | SDG MACERICH PROPERT | 502011678526 | GS | CH7 | 5 | Commercial Heat - Demand Forgiveness | Mo |  | 1999-02-01 00:00:00 | Bundled | 34.1 | 19 | 19 |  | MIDD PE
 | AMERICAN COLLEGE | 502193051013 | HT | HT | 56 |  | Hr | 21 | 2000-02-01 00:00:00 | 2002-01-31 00:00:00 | 867.6 | 889.7 | 865.73 | 44.75 | PECO-ZONE
 | UNIVERSAL MACHINE  CO | 401304673312 | CM | GS | 6 |  | Mo | 13 | 2000-02-17 00:00:00 | Expired | 285.3 | 255.79 | 279.5 | 46.01 | PECO-ZONE
 | WILLARD  INC. | 400593080015 | GS | PD | 60 |  | Mo | 05 | 2000-01-20 00:00:00 | Expired | 316 | 289.26 | 316.08 | 48.38 | PECO-ZONE
 | SUBURBAN AIR SPIRAL | 401570029512 | CM | GS | 4 |  | Mo | 15 | 2000-01-22 00:00:00 | Expired | 21.5 | 20 | 19.86 | 52.1 | PECO-ZONE
 | WILLARD INC. | 450153081994 | CM | GS | 6 |  | Mo | 01 | 2000-02-02 00:00:00 | Expired | 57 | 33.47 | 33.26 | 55.05 | PECO-ZONE
 | LEHIGH VALLEY DAIRIES | 40219321001801 | HT | HT | 53 |  | Hr | 21 | 2000-07-01 00:00:00 | Bundled | 2876.8 | 2494.67 | 2725.96 |  | PECO-ZONE
 | LEHIGH VALLEY DAIRIES | 400193211029 | EO | POL | 73 |  | UM |  | 2000-06-02 00:00:00 | Bundled |  |  |  |  | PECO-ZONE
 | PRUDENTIAL INS CO AMER | 040089206001501 | HT | HT | 54 |  | Hr | 8 | 2000-07-13 00:00:00 | Bundled | 5507.6 | 4924.31 | 5380.87 |  | PECO-ZONE