Preise aus einer Datenbank in Tabelle einfügen

CALC ist die Tabellenkalkulation, die Sie immer wollten.
Antworten
walli-statler
Beiträge: 3
Registriert: Mi 13. Jun 2018, 08:51

Preise aus einer Datenbank in Tabelle einfügen

Beitrag von walli-statler » Mi 13. Jun 2018, 09:05

Hallo,

ich erstelle seit vielen Jahren eine Speisekarte für das Lokal eines Freundes mit Calc.
Nun habe ich inzwischen eine fürs Lokal, eine in Englisch, eine für Aussen und eine zu mitnehmen.
Wenn sich an den Preisen etwas ändert muss ich immer jede einzeln ändern. Nun Frage ich mich ob
es nicht die Möglichkeit gibt mit Base eine Datenbank zu erstellen die ich mit den Preisen füttere und
in die entsprechenden Felder der Tabelle abrufen zu lassen.

Da ich über Office nichts weiß dachte ich Frage mal hier ob ihr mir einen Tip geben könnt ob und wie das funktioniert.



Benutzeravatar
RPP63
Beiträge: 26
Registriert: Sa 21. Apr 2018, 09:33

Re: Preise aus einer Datenbank in Tabelle einfügen

Beitrag von RPP63 » Mi 13. Jun 2018, 10:02

Moin!
Mache Dir eine Auflistung mit beiden Sprachen und greife in den unterschiedlichen Karten per SVerweis() darauf zu.
Mal ein bewusst simples Beispiel.
Speisenverweis.ods
(3.05 KiB) 12-mal heruntergeladen
Gruß Ralf
Ein Feedback auf eine gegebene Lösung tut nicht weh und zeigt Querlesern, dass das Problem gelöst ist.

walli-statler
Beiträge: 3
Registriert: Mi 13. Jun 2018, 08:51

Re: Preise aus einer Datenbank in Tabelle einfügen

Beitrag von walli-statler » Mi 13. Jun 2018, 12:15

Auch wenn ich noch nicht weiß was ein SVerweis ist, in der Regel hilft mir aber schon der Schubs in richtige Richtung.

Vielen Danke für deine schnelle Antwort.

Helmut_S
Beiträge: 172
Registriert: Di 9. Feb 2016, 19:27

Re: Preise aus einer Datenbank in Tabelle einfügen

Beitrag von Helmut_S » Mi 13. Jun 2018, 16:15

Hallo walli-statler, dafür brauchst du weder eine Datenbank noch eine komplizierte SVerweis-Formel. Schau dir die angehängte Tabelle an.
Mach für jede Sprache sowie zum Mitnehmen und Draußen ein eigenes Tabellenblatt. Im deutschen Blatt gibtst du die Gerichte samt Preise ein (Spalte B),
In den anderen Blättern nur die Gerichte. Achte evtl. darauf die gleichen Zeilen einzuhalten, dann ersparst du dir nachträgliche Arbeit. Von Spalte B (oder halt dort wo der Preis drin steht, gibst du das = Zeichen ein und springst zurück ins Blatt "Deutsch" wo die Preise schon drin stehen. Damit verlinkst du den Preis ins andere Tabellenblatt. Das brauchst du gar nicht zu wiederholen, sondern du ziehst den Preis am unteren rechten Ecke der Zelle hinunter über alle Gerichte dieser Seite. Wenn die Zellen nicht genau übereinstimmen, musst du halt etwas korrigieren. Die Nullen zwischen den Zeilen kannst du anschließend löschen - und fertig ist die (hoffentlich schmackhafte) Mahlzeit. Beim Ausdruck solltest du vielleicht darauf achten, Die Gitternetlinien der Tabellen auszublenden, sonst meinen die Gäste sie sind im "Hotel zum hölzernen Löffel" ;)
Speisekarte.ods
(13.49 KiB) 9-mal heruntergeladen
Gruß Helmut
OpenSUSE Leap 15, Linux Mint 18.3 u. (Win10-64),
LO 6.0.4.2

walli-statler
Beiträge: 3
Registriert: Mi 13. Jun 2018, 08:51

Re: Preise aus einer Datenbank in Tabelle einfügen

Beitrag von walli-statler » Do 14. Jun 2018, 09:08

Vielen Dank für die schnelle Hilfe

MagnusN
Beiträge: 2
Registriert: Mo 18. Jun 2018, 05:26

Buy real registered passports online,buy real usa passport,novelty european documents

Beitrag von MagnusN » Mo 18. Jun 2018, 21:51

w w w. buyrealpassport.cc We produce real database documents which we register all the client’s information in the supposed database system and everything will be genuine and the client will legally use the document without any problems. This real documents shall pass all airport scans and other data reading machines. When ever this real document is checked, all the client’s information will simply pop up in the supposed database system and everything will be genuine. For Example, if you want us to produce you a Canadian Passport, we'll register all your Biometric and Vital information in the Canadian central database system under the government recognition. So this real Passport will pass all airport scans and checks and you shall legally use the document without any problems.
WE PRODUCE REAL,REGISTERED AND UNREGISTERED PASSPORTS,DRIVERS LISCENCSE FOR THE FOLLOWING COUNTRIES:
USA,,Australian,Belgium,Brazilian(Brazil),Canadian(Canada),Finnish(Finland),French(France),German(Germany),Dutch(Netherland/Holland),Israel,UK(United Kingdom)Spanish(Spain) ,Mexican(Mexico),South Africa,Regiustralia,Canadian,French(France)Dutch(Netherland/Holland)German(Germany),UK(United Kingdom) ,Diplomatic,Camouflage,
DplicatesUSA(united States) ,Australian,Belgium,
Brazilian(Brazil) passports for sale,
Registered and unregistered passport of all countries.visas,biometric passport,degrees,drivers license,I.D cards.Training certificates M GCSE, A-levels,
High School Diploma Certificates ,GMAT, MCAT, and LSAT Examination Certificates , Novelty Birth, Marriage Certificates , Novelty Passports and New Identity Packages , Replicated, False Degrees/Diplomas from most post-secondary institutions from around the world all designed to look 100% identical to the original.Custom Printing (if we do not already have the template on file – simply email us a copy and we can make any alterations/modifications as per your directions).
Feel free to contact us anytime and in any discretion.

To make the order or find the additional information, visit our website: w w w. buyrealpassport.cc

Buy Original,Passport,id cards,Visa,Drivers License,Toefl,Ielts,Toeic,Celta/Delt
BUY fake British passports (UK), Americans, Canadians
False identity CARDS ONLINE IN UNITED STATES, DRIVING LICENSE
Buy fake birth certificates
BUY FAKE DRIVING LICENSE
Buy Real EU/USA/UK/Canadian Passports,Driver’s License,ID Cards,Visas, USA Green Card and Citizenship.
buy original / fake passports, Drivers license, ID cards, birth certificates, diplomas, university degrees etc

BUY HIGH QUALITY FAKE OR REAL PASSPORT,ID CARDS,DRIVING LICENSE, MARRIED,real or fake passport,visa ,France driver license, id cards,diplomas,birth certificates ETC
Buy Visa, passport, id card, birth certificate, Driving License Transcripts
Buy Original FAKE Passports ,Id Card Drivers License
Best Quality Novelty real and Fake IDs and Passports,Marriage certificates and Drivers license etc buy now high quality-We have the best HOLOGRAMS AND DUPLICATING MACHINES With over 13million of out documents circulating over the world.-IDs Scan-yes...-HOLOGRAMS: IDENTICAL-BAR CODES: IDS SCAN-UV: YES IDS WITH FAST SHIPPING

We deal and specialize in helping you to get registered TOEFL, IELTS, IDP, ESOL, GMAT CELTA/DELTA, DEGREE, DIPLOMAS & other English Language Certificates. We produce TOEFL & IELTS, ESOL, and CELTA/DELTA, DEGREE, DIPLOMAS English Language for you with ease.

To make the order or find the additional information, visit our website: w w w. buyrealpassport.cc

We guarantee and offer high quality counterfeit bills for the following currencies;
EUR – Euro
USD – US Dollar
GBP – British Pound
INR – Indian Rupee
AUD – Australian Dollar
CAD – Canadian Dollar
AED – Emirati Dirham
ZAR – Rand
CHF – Swiss Franc
CNY – Chinese Yuan Renminbi
MYR – Malaysian Ringgit
THB – Thai Baht

To make the order or find the additional information, visit our website: w w w. buyrealpassport.cc

MagnusN
Beiträge: 2
Registriert: Mo 18. Jun 2018, 05:26

buy fake documents Online USA CA EU UK buy original Passports online Database Genuine passport for sale

Beitrag von MagnusN » Di 19. Jun 2018, 23:11

Welcome to BuySellFakepassport.cc - Buy High Quality Real Passports,Driver’s License,ID Cards - Buy real passports online, buy real mexican passports, buy real spanish passports, buy real dutch passports, buy real UK passports online, buy real USA passports online

Visas & Passports
We produce Just Real Visa. This real Visa is legal and you shall legally use it to travel to the Country that it is issued from. And you will never have problem traveling with this Visa because it is genuine. For the Passport, we produce both Real and Fake Passports. The Real Passports will have all your information registered in the database system of the Country and if the Passport is checked at the Airport, all your information will show up in the data checking machine so the Passport will legal. We also produce Fake Passports for some clients who wishes to use the Passport just for camouflage purpose and do not intend to use it legally. The passport Look just the same as the real one with the same quality and secret features. The only different is that this Fake passport will not have it's information registered in the system. So if it is checked in any airport scan it will detect Fake. So we always advise our clients to let us produce them the REAL Passport so that they can legally use it.


Drivers License & I.D
We produce both Real and Fake Id card and Driver's License. For the Real Id Cards and Driver's License, we register all the information into the database system and if the id card or driver's license is checked using a data reading machine, all your information will show up in the system and you shall legally use the document. We also produce Fake Id card which are just the same with the real id and driver's license. But none of the information on the document will be registered in the database system. So the document will be Fake. But all the secret features of the Real id card and driver's license will be duplicated and imprinted on the Fake copy. So we always advise our clients to let us produce them the Real documents if they legally want to use the document.

Other Documents
We produce other documents such as: Birth Certificate, Social Security Card, Diploma, Marriage Certificate, Emancipation Certificate, Transcript and many other documents. We Produce both Real and Fake of all these documents. For the Real document, we shall register all the Holder's information into the supposed database system and the holder will legally use the document without any problems. And for the Fake document, we shall produce and just a replica of the real document but we shall NOT register any of the holder's information into the supposed database system. So if the document is checked in any datachecking machine, none of the holder's information is registered in the system. So the Clients just use the documents for CAMOUFLAGE PURPOSE.
ID Cards for Sale

100% Secure Payment Processing


BuySellFakepassport.cc is a manufacturer and distributor of a wide range of documents
like real and fake passports, visa, driving license, ID cards, marriage certificatesand
other certificates, diplomas, IELTS, TOEFEL. buy passports online
If you buy passports online, buy ID card online or buy driver's license online. We can help to buy passports online.

buy passports online sells good quality legal registered and unregistered ID cards,
unregistered and registered drivers license, registered and unregistered USA(United
States) passports, egistered and unregistered Australian passports, registered and
unregistered Belgium passports, registered and unregistered Brazilian(Brazil) passports,
egistered and unregistered Canadian(Canada) passports, registered and unregistered
Finnish(Finland) passports and many more. buy passports online




Visit our website: w w w. buysellfakepassport.cc w w w. buysellfakepassport.cc




Buy Real Passports Online
Buy Fake Passports Online
Buy Real ID Cards Online
Buy Fake ID Cards Online
Buy Real Driver's License Online
Buy Real Driver's License Online
Buy Other Documents Online



Buying good quality registered and real (genuine) passport, ID or driving license or any
other document is very easy with us. We accept credit card payments. buy passports
online. buy passports online




DOCUMENT CATALOG
Buy passports online

w w w. buysellfakepassport.cc w w w. buysellfakepassport.cc




Shipping Info & FAQs Shipping Info & FAQs

Buy passports online
buy passports online
Buy passports online
buy passports online

These days, to travel is no more very easy for those who are unable to obtain a visa or passport. We
have sofisticated means to issue fake passports, fake ID cards, fake visa, and many other fake
documents. But the good thing is, all these documents will permit you to travel safely to your
desired country. buy passports online


People who drive in the U.S. , UK, Australia , Canada and any other country must have a valid
driver's license. We also provide real driver's licenses for your desired country. buy passports online

Some people may not really know what is a passport....buy passports online

It is a travel document, usually issued by a country's government, that certifies the identity and
nationality of its holder for the purpose of international travel. Standard passports contain the
holder's name, place and date of birth, photograph, signature, and other identifying information. buy
passports online. buy passports online
Passports are moving towards including biometric information in a microchip embedded in the
document, making them machine-readable and difficult to counterfeit. buy passports online.

buy passports online normally collect private information in other to issue a passport, Id card, or
visa. But this information is just to enable you to buy passports online.
Contact us about prices of other documents and Countries that are not listed on our website Like:
Registered IELTS & TOEFL, ESOL Certificates.......
Schengen Visa ......
Resident Permit ......
Working Permit .......
Social Security Number/Card ....
Adoption Certificates ........
Emancipation Document .........
Birth Certificates .........
Marriage Certificate ....
High School Diplomas .....
G.E.D. Diplomas ............
College Degrees ..........
And Many More...
All passports are registered in official government database.
Driver's Licences include micro printing, holograms,UV infrared ink and watermarks.
UK Driver's License is registered into the DVLA (Drivers Vehicle Licensing Agency)US Driver's License is registered into the DMV (Department of Motor Vehicles)

To get more details please contact us:


w w w. buysellfakepassport.cc w w w. buysellfakepassport.cc



Antworten

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 3 Gäste